﻿      
     
      
create proc danhmucphongBan_xoa          
@MaPB varchar(25)          
as          
declare @dem as int          
select @dem=COUNT(*) from DanhMuc_PhongBan where MaPB=@MaPB       
if(@dem>0)          
begin          
      
delete from  DanhMuc_PhongBan where MaPB=@MaPB              
select ErrCode=1          
end          
else          
begin          
          
select ErrCode=0          
end     
    
